package ${package.Controller?replace(".controller","")}.sys.dao;


import ${package.Entity}.SysMenu;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author yiming
* @title: SysMenuDao
* @projectName property
* @description: TODO
* @date 2019/6/2615:10
*/
public interface SysMenuDao {
@Select("SELECT m.sys_menu_id sys_menu_id, name, parent_code, url, perms, type, icon, priority, create_time, status from  sys_role_n_sys_menu rm left join sys_menu m on rm.sys_menu_id=m.sys_menu_id WHERE rm.sys_role_id=${r'#{roleId}'}")
List<SysMenu> getByRoleId(String roleId);
    }
